SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 720014 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 720014 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024730,393832,132640,1012634,738834,55756,53426,611994,404049,83770,431587,40474,970413,838285,1009806,48167,1020487,915705,29622,385953,443321,844532,577737,678165,917167,133003,534252,624746,340801,68502,881378,1016169,548905,677180,467447,743207,819587,495224,89468,625305,629005,251111,248364,698058,948688,549813,821887,878846,322077,917585,472704,614010,954542,521239,147406,472441,756063,541776,230140,679501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 720014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 720014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]