SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252909 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252909 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415131,1047022,1007258,868756,734124,77044,346297,350841,146587,977337,756615,671985,638814,938636,817273,451731,231242,294689,835898,788823,415869,158966,488423,736442,583124,264142,505868,124651,324042,533532,480492,288732,346518,622861,393766,1017073,261802,255132,435590,674248,684042,743789,1001152,407736,728159,309437,804007,866444,675075,789826,718629,680690,690006,260269,899405,587,923772,1035315,728967,557359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]