SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470948 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470948 [ RunTime:0.003149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818614,14336,262899,152356,116073,1047414,957552,520530,674888,265062,34109,899473,448389,725702,829412,651793,877933,970905,653258,228711,768158,358512,341683,441650,974484,177314,439323,89100,178555,114544,42606,564786,235409,659084,62594,1034598,554076,508421,248362,81874,400469,1047617,881791,178089,546645,269810,507860,940194,747149,163618,642472,136200,715994,886270,507982,672242,310381,982303,685980,177112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001761s ]