SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68835 LIMIT 1 [ RunTime:0.001307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68835 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413331,913583,972764,847417,1041555,464905,123856,334102,434732,967840,194964,858476,1029844,546095,11150,122756,601444,353055,1042745,580445,475805,248100,920834,799772,755157,967656,644393,620058,285084,718001,965579,283923,1000062,800727,771656,980719,876819,251592,725745,960099,1003712,139184,745484,741221,339579,102380,114319,316278,200339,245375,538755,975679,299858,516090,266449,423963,839058,597039,705349,644522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001371s ]