SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438534 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438534 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22791,487578,626068,535462,617704,1046481,976042,974342,154093,662556,517730,137386,841821,473851,172467,984392,431101,694860,799275,989867,931319,621424,530449,96185,603250,274337,992696,43136,823244,892415,117730,942681,712088,239675,335722,321419,155888,148675,139317,143182,779698,375197,350646,377566,101319,118471,946314,329182,912147,761849,508231,743527,339815,838324,870218,651894,690967,440188,26502,154983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005043s ]