SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517713 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517713 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334929,930542,590534,892296,544741,1001748,646001,197482,826503,999042,272900,169199,632120,789176,173168,734548,326614,426976,345811,402795,1045553,733655,820163,1011264,599788,874259,468431,976997,622363,928036,309396,126251,511055,360570,307094,422836,654523,852741,348109,890736,444255,85894,419574,38649,186873,326764,771469,239979,1028008,797629,1038512,721632,736770,533024,139248,779552,721879,649546,366684,596224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]