SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447199 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447199 [ RunTime:0.003216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380568,703477,417068,993831,388743,83087,537636,146372,869563,298706,402840,988278,865793,1006861,358717,930134,674443,923954,566280,172047,478664,163002,786492,280649,149917,903790,337286,59761,53254,123247,693531,911438,234902,694277,672942,501297,304800,464885,73526,848137,777350,204711,365312,196593,382241,170502,823447,694590,1030564,399577,86588,34257,449800,349178,165305,379881,986984,298574,565642,609448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]