SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026372 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026372 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72827,38827,898174,429104,419545,678397,192265,301120,1048614,445452,142502,825266,830569,21037,16518,375764,100762,539890,619617,382365,517358,389849,303452,946080,501134,147594,129620,590650,293011,334042,889556,399806,329697,587863,623038,165239,334691,713116,496854,199704,21449,646205,269656,218452,612236,622390,965548,208747,859948,363159,52094,487890,739757,919185,495764,554664,184182,582552,537127,34394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026372 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026372 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]