SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108308 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108308 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856159,1023931,796798,312851,441584,853255,241010,451078,98988,901266,421570,157324,192986,953350,265815,750641,475558,511856,630866,821580,784185,980638,80325,205130,292708,434737,388849,558154,783069,327677,806532,1013804,777957,33758,677459,534875,80052,55569,524294,487534,51874,221069,1047925,430833,749906,465323,63149,288043,183925,334898,289225,906315,495867,622203,485472,454209,740691,926383,920612,928904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]