SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44110 LIMIT 1 [ RunTime:0.000698s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44110 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19544,53813,795249,626442,543730,278305,289684,976853,40657,360301,619792,86081,629050,481110,318166,499253,359488,213843,651247,460946,756198,625946,333100,542507,601621,400508,110231,83986,958117,753663,362658,166277,671958,29749,438470,844049,833997,167752,305984,343464,345808,522762,337469,659686,18986,596077,336865,881561,748705,141877,994642,465408,220687,434084,69706,32031,264439,287913,611288,406386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]