SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034390 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034390 [ RunTime:0.003534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382087,599575,564032,139463,719251,184837,117777,197256,262239,333644,636028,708040,595059,429776,467110,849827,294085,919971,43773,620599,796871,723845,570452,119227,398448,349573,106944,616091,742808,994310,94709,780875,237722,489538,269956,242834,6458,13240,18317,997255,877810,68614,986807,549994,979685,55364,492493,883083,748961,87747,241274,959244,519234,414925,416170,386905,140272,165074,116668,276412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]