SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445012 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445012 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771679,489478,300231,1014082,627851,952342,637561,534357,486628,353043,161308,330068,223942,29828,252113,731556,628715,584535,57919,613520,289220,516780,980329,139587,360233,210397,613552,20009,11066,508930,1040970,574716,10576,229498,672288,617968,230336,472201,441653,539112,158041,111808,824326,538569,424852,276529,775489,375304,771663,472800,171136,291696,860027,587695,1045738,320899,152019,731819,766444,834456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]