SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191073 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191073 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644212,240826,105102,154986,861206,247557,724587,103834,970009,768698,984449,283198,343407,221636,1014776,437331,113294,557536,590537,599068,211984,14486,270621,964862,212484,206524,358475,571734,927549,968599,511640,576959,75090,237202,125008,184583,101177,715327,562153,998291,266416,102153,333638,1002783,439361,906819,296797,193944,777543,1029348,555447,1046479,516015,955995,308495,376355,979933,1011355,874650,805402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]