SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565209 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565209 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608754,221470,266126,547103,214216,190380,287399,61640,551850,300438,415142,329401,598945,141010,12870,13559,455946,567172,754487,819988,633435,902660,973000,121905,246984,689133,228854,103927,865340,941546,780345,907306,944917,406191,927662,886264,852702,525686,707615,108226,566874,765189,780219,13846,637546,374374,712718,126846,1000868,413789,839714,271729,77672,817254,48911,979815,978488,513135,686283,281352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]