SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511205 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511205 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703414,604291,855285,276259,574196,53765,392782,399242,103401,658361,228767,82170,370658,422604,103187,381813,620315,390143,825347,483663,373939,619871,612758,59216,296937,817161,979311,784483,548578,112668,17508,523043,283851,893404,943568,848406,1011042,1036827,784354,974511,232391,87918,833887,269595,897818,444605,346622,520147,561956,969400,503503,172538,349355,620993,339325,1041469,31293,1022459,182011,628413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001027s ]