SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555896 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555896 [ RunTime:0.004994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64879,565810,456629,322314,200737,907711,124705,925374,653124,117792,353878,861430,497250,169583,239745,627183,700349,924283,949477,482517,755331,359110,864080,643780,601947,871075,91488,530552,133493,792511,285039,832445,180180,11081,957669,55092,661759,874820,146439,104127,496458,745869,707087,791871,301765,961189,705531,221482,78528,912539,673227,653926,825737,703946,75923,389421,447393,888181,129529,693685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]