SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405273 LIMIT 1 [ RunTime:0.002387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405273 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940264,303364,135708,145259,721324,543740,217745,50255,400204,897787,28727,101186,201690,646264,109977,975743,822959,917377,376446,619511,485296,961108,650924,797679,480293,909827,719535,896424,868591,300833,62156,485477,91766,124928,575980,463424,447473,172638,137003,505848,544518,628116,818063,753411,651646,1030402,287544,1037538,839430,351273,450489,276709,670017,400741,158582,201844,768276,39280,876473,655700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.035490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002475s ]