SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34774 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34774 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923403,321419,625529,20071,439553,886429,616628,793342,148680,398469,132708,93377,129249,431484,873209,684928,169052,65276,519153,801043,195848,351431,250966,573277,150062,414795,148350,61663,481968,385359,497926,88959,428988,52266,608435,731773,567114,577607,825800,187061,158906,512280,735518,398551,716294,1038612,588006,507336,817584,42862,245455,108215,659756,421451,487656,257458,185666,933460,95175,905272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]