SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029435 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029435 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560227,184125,635837,126103,681175,544240,433023,314293,572537,515756,988895,922564,83733,892193,549657,231057,823490,82562,207783,275678,519033,736485,484176,15859,672711,547718,795705,510590,415261,787399,730413,514698,476496,319734,522343,565198,99064,438984,205605,563543,569085,420395,479985,918718,389254,669176,444133,549382,813266,785113,70256,508186,805241,481983,625556,118743,271151,264517,297366,640933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]