SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34233 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34233 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257457,948062,811967,906976,806289,27806,797046,821826,772075,77907,487012,482695,273963,796974,731581,160037,627267,502030,1018984,745422,110131,652751,750533,256650,538715,305261,865867,918774,1031999,629184,439110,398220,316014,288154,18545,441237,782063,346421,991594,124741,499361,442538,448066,503114,480740,1040650,814649,722395,275457,358146,363837,493504,624121,249671,532751,84609,46597,150998,1024019,1015888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]