SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809638 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809638 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479925,787514,422412,765860,482603,148651,832691,902834,486761,95194,349666,378840,39804,307840,743556,6039,72371,1007131,360020,521655,619913,643150,454690,39193,768129,996708,525117,865717,416401,932937,578913,631366,145327,519290,942115,108536,500696,689713,520129,637317,571659,723045,181328,164762,233880,168059,13186,1040322,191082,66686,465550,452126,165480,53323,180730,905967,156257,585148,773160,653347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]