SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805008 LIMIT 1 [ RunTime:0.000914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805008 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859905,74312,870647,531799,668777,1035530,199670,475008,428988,672399,519283,84978,905389,163997,213923,544209,953250,590973,92800,1047086,684564,877496,714994,722119,156870,480670,163915,892039,875352,311028,240216,921359,578240,87781,806164,690371,670078,171768,299907,492967,843304,669708,242525,696730,310073,454349,772116,227029,316463,447024,148694,344669,897363,244767,762344,419557,516187,928843,691556,717480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]