SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557876 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557876 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151132,359830,4183,841599,422575,386579,277496,689944,447519,491523,1034392,689553,618117,392141,684604,995,342074,890089,284490,50004,1047260,337810,831151,668872,200051,615077,909101,569840,337768,51171,438616,208457,762680,760252,430092,725639,707424,954524,347259,474160,1042156,585052,418762,266899,424787,925928,82032,40534,748313,338281,467536,151719,760353,795225,636865,102537,439406,513751,111799,334162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]