SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654011 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654011 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989202,707583,565217,185102,276935,720940,375988,203415,974068,271315,986793,400586,44717,881810,1000705,786984,790245,93580,651732,325943,578706,10081,43543,297753,725225,624105,1027608,556834,498637,296558,895522,792516,684626,982600,804541,588972,225564,702130,357430,34929,874547,936720,1003197,961523,562351,714580,782483,659227,591785,732217,677483,938634,228056,700296,754213,568160,463122,413262,911029,954066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]