SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200630 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200630 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410733,670515,252482,692520,140927,507526,209917,949763,309519,674091,267168,394856,786235,391183,1007717,866160,954896,622884,223141,893082,707003,869306,638684,74351,207150,730663,302105,724553,1033342,428342,803738,477554,736822,174226,143490,641371,231549,398054,382484,56610,244033,355503,569789,821577,63397,494808,769051,640257,220483,124806,265655,535864,11417,850088,664615,912922,127876,135665,197731,417887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]