SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577283 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577283 [ RunTime:0.002193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481329,5815,204747,583921,369627,49679,170488,907847,804360,262103,442016,167474,342771,968924,617365,675590,797284,84810,530636,1006157,921618,813653,967749,992135,1030090,270758,858972,917766,673888,468494,715634,160595,523301,425353,177762,492335,373405,1047839,623492,831801,194652,138712,66469,411639,958097,28874,204376,390171,991166,279065,550084,961354,534281,873873,549812,267956,540609,29827,796309,601744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]