SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520142 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520142 [ RunTime:0.005426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450488,855320,566751,543598,369346,923288,203790,160836,91902,839402,885911,450719,363936,897401,347158,618894,739294,791792,177847,151717,106056,973376,942615,104799,339906,593588,527571,1030283,689113,341442,650594,1005052,876225,858304,514757,846533,549456,36034,350103,626678,32642,448515,575209,431379,137551,307250,356812,211872,282184,259108,795917,309581,241679,465635,957310,146088,340257,230430,312055,576780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]