SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038522 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038522 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305592,116415,826820,660808,195297,611025,67424,764091,260907,142295,520959,143990,575671,1018197,922972,487480,418855,599748,20496,626654,172001,320391,75613,648050,438387,192756,152891,806462,621758,542656,560960,985879,838487,988818,655746,748363,877205,597364,891894,356837,632744,658630,876927,732651,495555,32618,305480,69329,398741,725701,452197,245332,125763,769555,796503,63889,789123,946732,960001,988546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]