SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542080 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542080 [ RunTime:0.003965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861300,872680,989548,499680,902995,423012,606616,504472,713833,951879,183695,215130,80749,493305,235599,984826,1045370,433087,578231,664585,780152,994372,295573,929355,833647,92748,585242,870227,851476,134606,670477,11990,601472,726345,829688,1044654,147222,235233,896139,498793,636538,280040,156829,117152,1023054,278337,731476,917949,814650,889728,98033,533896,1046460,717090,388009,390439,270220,379797,106941,147109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001367s ]