SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456213 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456213 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10529,365728,456282,324569,30865,119638,829135,576347,344,447238,711185,393359,1042273,697177,65169,1045042,981579,104694,951823,763223,741794,255713,725982,496257,806766,905145,436144,398111,258929,250683,290099,617294,663109,742314,190884,934609,449797,347622,202662,561184,225987,562510,828921,69506,949917,322653,428439,1009262,97487,996250,1010452,338307,339668,252882,279175,482290,910084,560806,831417,641224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]