SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334149 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334149 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843053,648249,1030257,196028,870169,21122,359208,92537,189371,89668,802441,598248,721948,802584,366770,736475,785911,311839,323861,1037627,46930,905790,453601,50035,508098,490680,503376,931755,813444,859851,1029040,781489,886382,876873,197585,42609,511135,842850,824142,388878,135952,290080,512880,497148,22484,774554,377210,144250,803576,256033,38378,403458,555339,310099,3902,874931,242845,25600,163964,912033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]