SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535392 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535392 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48176,1041427,935046,222273,338691,190637,835042,172495,259183,42423,414341,191570,975395,841193,424424,722910,577509,972819,391180,327591,195851,883632,886328,491323,795446,892120,643684,41596,680887,482521,429349,51781,361141,377732,902558,625386,676508,364681,758250,835658,644963,69959,284647,451637,307160,593224,50876,538229,590003,281183,964624,1039807,899351,621544,813449,244037,990389,919080,494693,1014445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]