SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535799 LIMIT 1 [ RunTime:0.001116s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535799 [ RunTime:0.002739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324206,665681,209110,234233,762871,929348,270689,400451,875953,175087,550139,237805,539924,470770,189448,817420,726243,485194,779060,594457,233706,992752,384352,14362,340893,772300,580622,309464,758657,172012,524882,774201,961457,590072,703272,209061,786194,513143,921993,579136,523673,207808,430672,761490,853828,432378,862220,724398,120601,624894,988615,813970,920120,786988,146592,959476,633007,592365,9207,372921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001476s ]