SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242007 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242007 [ RunTime:0.003760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818976,368870,31512,351777,626934,102011,856309,1005468,464712,445941,49028,233019,620694,803886,435047,906736,786005,74448,356504,799565,600714,532143,868588,1023701,480884,495387,736313,420305,808651,208195,84720,36200,254689,541571,360090,903438,669845,272522,406125,573588,837797,811515,74131,794367,969717,778639,854285,453667,963796,167625,7076,555537,497539,725586,112694,570437,587581,236840,534132,114368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]