SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550863 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550863 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156614,189351,117821,860912,941559,595114,584695,160316,734278,427540,381196,79162,471570,206276,780078,903082,195083,106742,959403,571959,467177,506526,783651,1026684,184276,866023,160771,775949,472927,461124,812997,498237,873599,527777,53696,595855,356088,448715,555172,293514,43204,314564,752347,141991,338087,138926,813961,380538,532677,206149,192430,548221,527983,150700,139581,707407,1024547,900829,771443,483062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]