SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416018 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416018 [ RunTime:0.006268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53470,831563,47333,273317,952221,682968,862744,389284,955044,205308,992894,593393,575580,639995,760390,254398,779532,79361,698486,711899,433234,451202,508118,65896,995917,471928,295029,770403,656337,80105,298546,849415,312605,847189,128861,783399,871900,259190,310580,447641,872694,543122,223833,429497,778787,786816,946916,272422,12125,366319,543778,325845,691095,991112,374769,647192,349497,460060,1040906,55717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]