SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012140 LIMIT 1 [ RunTime:0.001498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012140 [ RunTime:0.005207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287047,598770,688150,843275,308615,964104,238812,412657,536269,207272,699061,610997,1008966,277095,970138,221198,731690,454274,213102,864114,673311,958716,472709,879147,284311,173085,559743,330587,262673,1041141,381313,366436,772072,625749,172782,697674,226957,546703,931658,958307,63243,125693,125504,450677,602264,1035834,380604,815169,142471,562145,979574,976607,637471,932002,670686,504021,962368,770071,36918,669581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]