SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390081 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390081 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976869,251579,460479,1039664,1038967,9892,263794,768482,713513,821194,275287,756938,755298,678144,318383,325147,436227,1007627,877397,604362,950562,66094,409707,691020,760967,829800,293794,52977,335809,489077,903245,265437,212115,862859,631454,21180,300146,737401,962487,236343,515768,355889,411451,1005990,457722,273454,155905,987875,519489,141761,123765,31394,237329,1012385,730780,314236,282698,773433,544359,419519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]