SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271239 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271239 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569824,455467,771259,17691,158088,28385,695261,360026,1038543,411597,621336,342219,956830,1013586,564207,986853,63945,912570,1044457,451856,253719,7320,302866,204681,335185,694919,989310,434222,445775,144028,473922,94651,692865,147525,620800,1034994,481089,306688,240496,325700,1018097,911866,115287,597601,319475,90814,738644,460283,648138,995790,1037057,214990,691327,299710,86843,731945,536187,104566,131255,496214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]