SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392871 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392871 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513187,333750,570331,567719,787856,58786,209664,299133,392853,1043008,72038,783766,321904,355675,870104,779634,926428,292323,225861,777581,368743,839046,381805,419089,486194,11538,919893,241862,439650,523062,900627,716768,628383,626383,418263,644928,479371,489144,1006729,933233,545773,35035,940617,711695,773584,439702,405296,725154,970250,959640,356890,642268,386689,910904,335464,947822,872513,993316,858430,652893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]