SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518048 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518048 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25144,512472,381874,763193,68193,920883,340777,874838,716885,103944,274748,688267,986356,230212,395260,243490,167962,313829,939255,1043165,1015201,267614,800819,975138,479415,496657,1020440,575798,902198,411982,241254,984982,892448,288715,928159,667601,620440,403050,187855,73152,513680,891976,30591,702694,646682,900228,385794,270334,1009003,952158,341255,289529,258949,201413,764541,137598,22456,13676,261194,967410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]