SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249871 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249871 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754588,363754,882811,322174,743635,571565,350418,430597,671659,315404,637973,31387,114175,513923,135525,810388,752545,938384,1017426,965955,971990,200484,505739,265565,752498,1027599,195870,102469,529873,141694,311246,9719,902940,687518,472482,499145,626653,992439,846489,368238,167984,588710,1014703,250486,268888,962028,908582,379895,213968,732207,205358,898864,543830,314024,683376,558872,124363,145644,537530,829612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]