SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401306 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401306 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586995,793808,240127,269852,1015277,723809,951646,411681,853139,128049,167503,780684,592013,174421,212149,947809,225943,312266,798091,949452,655323,87800,601292,978028,396362,684804,231996,680608,752661,138749,281526,279173,518204,703174,29297,512611,107582,707899,977387,1038718,98846,811625,367409,123492,70247,1020688,940838,918974,981688,916191,962232,275429,574462,585798,331628,866184,829910,943686,56731,732193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]