SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499904 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499904 [ RunTime:0.004401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945211,921453,49572,479220,49224,299564,143603,501986,1028679,804529,1048483,551335,981688,503369,380672,386575,166651,977813,769572,151783,80269,872268,649819,953299,491485,947783,150915,128326,128434,920258,590702,305684,954682,41503,293588,63398,149498,335251,203812,316470,953209,487346,712905,87002,556454,301945,916789,228465,509339,670307,305255,197037,751900,571353,657481,311678,455635,639074,101283,893135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001579s ]