SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460743 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460743 [ RunTime:0.003281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996338,235746,316294,813389,639318,552314,467875,973449,255825,667264,650033,1038768,58215,863830,788729,788589,371815,724706,546072,512698,86125,434357,807769,822097,1012982,1017471,741510,574642,720368,506979,61245,317344,788388,224734,462614,203292,984080,736393,950985,1004636,994569,46681,156806,191885,358873,140909,625932,845331,651666,376224,524661,1034152,584537,102054,232339,329246,784232,214833,611029,673179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]