SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047604 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047604 [ RunTime:0.010098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249196,533337,470783,185835,244516,254185,697567,791197,812770,690626,83988,789878,411577,1011307,401210,156141,637845,702862,697011,244260,994075,392549,855466,714442,1033746,537425,1040510,161497,77076,463738,155566,823524,688852,1037432,217198,561422,970754,958484,896443,773497,1039866,940955,962203,929354,62749,462150,1004512,474042,435610,305951,810427,292754,1009893,278633,977038,483542,747408,164902,1031598,514941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]