SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003769s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047118 LIMIT 1 [ RunTime:0.006096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047118 [ RunTime:0.010801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846682,63763,610376,134679,1034849,104613,599493,187894,872090,360659,685469,965245,398900,890811,499162,165396,731524,997858,124976,26724,124516,859969,318971,754768,771425,321170,56370,467399,245642,486023,308852,510365,771506,503048,792152,562828,5413,320360,893798,489208,793138,786647,912744,380636,374560,694296,192412,1011576,276233,202780,435038,224127,281732,395366,1005627,795004,704503,666787,223924,227416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002486s ]