SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39138 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39138 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84532,876752,1035603,64192,334634,61593,759770,865246,718072,810531,597277,572554,85573,772637,807337,161154,292897,188880,883289,241252,1026652,527779,51607,18221,1043193,976974,483427,157394,786998,252749,486785,353495,852566,928521,768181,682464,68865,58610,871382,985225,225653,838971,259205,409183,706304,907033,142862,679102,571508,56836,312342,939735,828731,63077,520463,951518,813666,441329,619184,878854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002501s ]