SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263118 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263118 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507099,124977,894242,782730,131386,963243,109616,168662,688262,277100,726778,626182,318744,1025831,624403,158769,945313,533016,768162,710565,145047,953402,787302,133631,234824,944794,426381,559664,999459,1009723,534066,368700,455587,55593,545931,111222,550180,107824,807817,212436,484784,549419,984690,96714,98504,437157,248952,7980,523984,389077,136198,23665,4732,26990,77990,335942,395503,884898,952878,888527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002931s ]