SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590031 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590031 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511632,413219,271997,569831,118710,507607,179601,497081,1021898,816763,709646,122026,629971,460676,497296,50361,628947,1032416,837062,1034516,878416,130503,532249,316542,331702,708830,206626,146768,624533,773594,440853,376335,966114,980540,700422,749224,697877,277803,357379,249423,401643,591705,397751,188624,1004987,1042969,398916,940160,310904,158356,666991,942463,816981,808202,951162,934230,93400,599285,261794,254701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]