SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46991 LIMIT 1 [ RunTime:0.001778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46991 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817384,637325,1047797,309120,122302,781556,105743,1000550,383763,1003548,131701,992810,635574,65952,1012830,804977,544695,303835,562049,377063,301145,1000552,113037,712827,193666,250216,160319,537178,460180,1005722,431647,852647,928727,513804,266002,1028982,239781,947395,289395,402792,978590,694844,273092,1020120,953009,158387,976751,720413,417053,801262,249598,926417,383717,329868,660720,904589,385459,370234,288351,572665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001627s ]