SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401596 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401596 [ RunTime:0.002399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9566,80829,202835,189697,270475,669527,597743,484089,474447,862243,474909,975900,390431,1005723,1023930,701065,973152,370016,177509,919784,354135,859604,228693,697867,740146,704400,775137,419539,1016298,719831,251258,523882,975400,981392,837526,1011877,992290,604871,944299,841355,862495,567177,25842,227818,125545,625297,97516,4798,433458,456789,728992,684184,705343,382255,604985,122214,275071,592447,827365,874464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001752s ]