SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475431 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475431 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727817,951422,92432,841469,69997,557598,416537,871437,356088,132384,150754,596252,179054,726793,514657,443853,15937,633294,241467,773707,593230,850855,278681,1000070,426844,687176,19133,145327,865478,673883,222981,884945,134907,369905,182014,866018,517409,485067,367875,1006582,950213,978119,596941,127509,356187,872316,285572,935688,305058,599280,985464,830513,44126,683641,942656,766954,222648,463425,42188,285515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]