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` = 391068 LIMIT 1 [ RunTime:0.004027s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391068 [ RunTime:0.010964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810536,501805,676063,48717,285172,597515,1018624,196867,953503,519320,477106,248633,926890,269497,826124,417513,753630,101612,865536,714027,725919,313672,741406,114086,999140,189082,633952,760904,722866,650930,759322,809459,734705,880720,105655,230198,501585,119513,983747,312052,511896,875994,816250,993640,981164,867661,816924,558927,700855,318373,949467,607475,406279,958626,870268,420731,45732,480628,348352,314411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]