SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335817 LIMIT 1 [ RunTime:0.001135s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335817 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332392,1000006,501486,62939,417654,992186,781622,155795,260797,873577,222280,631176,681716,627044,878176,391848,298474,745107,692460,199031,924910,460405,444885,964518,679771,981318,885924,137866,1023481,604427,997871,454845,189406,733679,990641,113002,314046,422081,491975,481460,88973,416475,599763,512903,571184,54269,593614,904518,69325,247837,149174,4637,816243,171919,549359,580026,896059,831538,10848,385379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]