SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292908 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292908 [ RunTime:0.003229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527440,938634,829721,112589,666247,468653,226999,453801,170025,536093,65049,769872,252752,50948,322121,1022091,919340,86656,203174,132084,937876,558113,784493,617744,793103,649186,831,741457,995404,378804,411083,320418,67773,991764,70265,416857,900402,299320,547709,302093,397301,125945,991929,663728,123607,404962,398402,721315,348107,1017062,492132,51695,185153,193959,575360,1045619,39288,822583,614431,1004460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]