SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008707s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 874243 LIMIT 1 [ RunTime:0.003162s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 874243 [ RunTime:0.008355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54679,277348,616923,1026053,105023,973945,467817,107623,305698,211051,544245,392692,796371,215084,634229,763139,147539,3736,110624,609961,460726,994567,664219,477860,996076,896540,571568,80381,931288,812445,392940,902313,672033,575144,3688,515967,254322,643245,250066,29234,810128,510838,501734,754530,212992,262863,189389,272923,642991,339306,506432,956773,1031106,248920,127603,31996,273092,474528,664822,671282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 874243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 874243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003028s ]