SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253420 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253420 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560415,1023533,1027483,1008319,797792,1028705,539311,776320,482450,46787,477175,180239,240301,498503,375195,683448,1038008,998241,433348,99111,885609,135377,903489,550939,434905,569628,351224,951642,394993,957940,748658,11631,522522,637513,299177,231469,306405,992349,977927,233501,401037,361584,1040920,828976,596971,162936,86285,997624,383705,149336,114686,234572,453564,609166,978553,749115,626411,304581,629141,257454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]