SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539947 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539947 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271912,468530,559745,1957,295735,89016,1041639,344140,573452,421017,840400,211870,1017043,874750,758241,229927,38185,203528,119407,779672,478641,115508,644228,688129,575431,668131,356770,49457,865085,871985,254436,733685,1032032,212218,1048414,57898,73181,167670,197352,731971,577575,112251,985933,215755,645889,732343,772826,1013004,95789,255518,526125,150044,362634,817085,221622,606139,261249,25953,259931,203072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]